﻿
	CREATE TABLE SUNRISE_NB.SE_GREENS 
	     (
	      ELU_ID CHAR(30) NOT NULL PRIMARY KEY,
	      ADDR_NBR CHAR(15),
	      STR_PRE_DIR_CD CHAR(2),
	      STR_NM VARCHAR(50),
	      UNIT_NBR CHAR(10),
	      FLOOR_NBR CHAR(10),
	      BLDG_NBR CHAR(10),
	      CITY CHAR(30),
	      STATE_CD CHAR(2),
	      ZIP_CD CHAR(5),
	      WIRE_CENTER CHAR(8),
	      LUID CHAR(10),
	      NETWORK_BUILD_TYPE_CD CHAR(10) CHECK (NETWORK_BUILD_TYPE_CD IN ('FTTN      ','FTTP      ','FTTP-EGPON','FTTP-GPON ','FTTPIP    ','RGPON     ')),
	      TECH_DNSTRM_BNDWTH DECIMAL(8,3) CHECK (TECH_DNSTRM_BNDWTH IN (0.000 ,37.120 ,43.820 ,30.001 ,19.000 ,19.264 ,46.400 ,28.500 ,-99.999 ,25.000 ,25.010 ,25.280 ,28.370 )),
	      CUST_DNSTRM_BNDWTH DECIMAL(8,3) CHECK (CUST_DNSTRM_BNDWTH IN (0.000 ,19.000 ,-99.999 ,0.100 ,13.000 )),
	      DA_CD CHAR(6))
